<?php

    /**
     * Created by PhpStorm.
     * User: nhw2h8s
     * Date: 7/2/14
     * Time: 5:45 PM
     */
    abstract class PHPExcel_Chart_Properties {
        const
            EXCEL_COLOR_TYPE_STANDARD = 'prstClr', EXCEL_COLOR_TYPE_SCHEME = 'schemeClr', EXCEL_COLOR_TYPE_ARGB = 'srgbClr';
        const
            AXIS_LABELS_LOW = 'low', AXIS_LABELS_HIGH = 'high', AXIS_LABELS_NEXT_TO = 'nextTo', AXIS_LABELS_NONE = 'none';
        const
            TICK_MARK_NONE = 'none', TICK_MARK_INSIDE = 'in', TICK_MARK_OUTSIDE = 'out', TICK_MARK_CROSS = 'cross';
        const
            HORIZONTAL_CROSSES_AUTOZERO = 'autoZero', HORIZONTAL_CROSSES_MAXIMUM = 'max';
        const
            FORMAT_CODE_GENERAL = 'General', FORMAT_CODE_NUMBER = '#,##0.00', FORMAT_CODE_CURRENCY = '$#,##0.00', FORMAT_CODE_ACCOUNTING = '_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)', FORMAT_CODE_DATE = 'm/d/yyyy', FORMAT_CODE_TIME = '[$-F400]h:mm:ss AM/PM', FORMAT_CODE_PERCENTAGE = '0.00%', FORMAT_CODE_FRACTION = '# ?/?', FORMAT_CODE_SCIENTIFIC = '0.00E+00', FORMAT_CODE_TEXT = '@', FORMAT_CODE_SPECIAL = '00000';
        const
            ORIENTATION_NORMAL = 'minMax', ORIENTATION_REVERSED = 'maxMin';
        const
            LINE_STYLE_COMPOUND_SIMPLE = 'sng', LINE_STYLE_COMPOUND_DOUBLE = 'dbl', LINE_STYLE_COMPOUND_THICKTHIN = 'thickThin', LINE_STYLE_COMPOUND_THINTHICK = 'thinThick', LINE_STYLE_COMPOUND_TRIPLE = 'tri', LINE_STYLE_DASH_SOLID = 'solid', LINE_STYLE_DASH_ROUND_DOT = 'sysDot', LINE_STYLE_DASH_SQUERE_DOT = 'sysDash', LINE_STYPE_DASH_DASH = 'dash', LINE_STYLE_DASH_DASH_DOT = 'dashDot', LINE_STYLE_DASH_LONG_DASH = 'lgDash', LINE_STYLE_DASH_LONG_DASH_DOT = 'lgDashDot', LINE_STYLE_DASH_LONG_DASH_DOT_DOT = 'lgDashDotDot', LINE_STYLE_CAP_SQUARE = 'sq', LINE_STYLE_CAP_ROUND = 'rnd', LINE_STYLE_CAP_FLAT = 'flat', LINE_STYLE_JOIN_ROUND = 'bevel', LINE_STYLE_JOIN_MITER = 'miter', LINE_STYLE_JOIN_BEVEL = 'bevel', LINE_STYLE_ARROW_TYPE_NOARROW = null, LINE_STYLE_ARROW_TYPE_ARROW = 'triangle', LINE_STYLE_ARROW_TYPE_OPEN = 'arrow', LINE_STYLE_ARROW_TYPE_STEALTH = 'stealth', LINE_STYLE_ARROW_TYPE_DIAMOND = 'diamond', LINE_STYLE_ARROW_TYPE_OVAL = 'oval', LINE_STYLE_ARROW_SIZE_1 = 1, LINE_STYLE_ARROW_SIZE_2 = 2, LINE_STYLE_ARROW_SIZE_3 = 3, LINE_STYLE_ARROW_SIZE_4 = 4, LINE_STYLE_ARROW_SIZE_5 = 5, LINE_STYLE_ARROW_SIZE_6 = 6, LINE_STYLE_ARROW_SIZE_7 = 7, LINE_STYLE_ARROW_SIZE_8 = 8, LINE_STYLE_ARROW_SIZE_9 = 9;
        const
            SHADOW_PRESETS_NOSHADOW = null, SHADOW_PRESETS_OUTER_BOTTTOM_RIGHT = 1, SHADOW_PRESETS_OUTER_BOTTOM = 2, SHADOW_PRESETS_OUTER_BOTTOM_LEFT = 3, SHADOW_PRESETS_OUTER_RIGHT = 4, SHADOW_PRESETS_OUTER_CENTER = 5, SHADOW_PRESETS_OUTER_LEFT = 6, SHADOW_PRESETS_OUTER_TOP_RIGHT = 7, SHADOW_PRESETS_OUTER_TOP = 8, SHADOW_PRESETS_OUTER_TOP_LEFT = 9, SHADOW_PRESETS_INNER_BOTTTOM_RIGHT = 10, SHADOW_PRESETS_INNER_BOTTOM = 11, SHADOW_PRESETS_INNER_BOTTOM_LEFT = 12, SHADOW_PRESETS_INNER_RIGHT = 13, SHADOW_PRESETS_INNER_CENTER = 14, SHADOW_PRESETS_INNER_LEFT = 15, SHADOW_PRESETS_INNER_TOP_RIGHT = 16, SHADOW_PRESETS_INNER_TOP = 17, SHADOW_PRESETS_INNER_TOP_LEFT = 18, SHADOW_PRESETS_PERSPECTIVE_BELOW = 19, SHADOW_PRESETS_PERSPECTIVE_UPPER_RIGHT = 20, SHADOW_PRESETS_PERSPECTIVE_UPPER_LEFT = 21, SHADOW_PRESETS_PERSPECTIVE_LOWER_RIGHT = 22, SHADOW_PRESETS_PERSPECTIVE_LOWER_LEFT = 23;

        protected function getExcelPointsWidth($width) {
            return $width * 12700;
        }

        protected function getExcelPointsAngle($angle) {
            return $angle * 60000;
        }

        protected function setColorProperties($color, $alpha, $type) {
            return [
                'type'  => (string)$type,
                'value' => (string)$color,
                'alpha' => (string)$this->getTrueAlpha($alpha)
            ];
        }

        protected function getTrueAlpha($alpha) {
            return (string)100 - $alpha . '000';
        }

        protected function getLineStyleArrowSize($array_selector, $array_kay_selector) {
            $sizes = [
                1 => ['w'   => 'sm',
                      'len' => 'sm'
                ],
                2 => [
                    'w'   => 'sm',
                    'len' => 'med'
                ],
                3 => [
                    'w'   => 'sm',
                    'len' => 'lg'
                ],
                4 => [
                    'w'   => 'med',
                    'len' => 'sm'
                ],
                5 => [
                    'w'   => 'med',
                    'len' => 'med'
                ],
                6 => [
                    'w'   => 'med',
                    'len' => 'lg'
                ],
                7 => [
                    'w'   => 'lg',
                    'len' => 'sm'
                ],
                8 => [
                    'w'   => 'lg',
                    'len' => 'med'
                ],
                9 => [
                    'w'   => 'lg',
                    'len' => 'lg'
                ]
            ];
            return $sizes[$array_selector][$array_kay_selector];
        }

        protected function getShadowPresetsMap($shadow_presets_option) {
            $presets_options = [
                //OUTER
                1  => [
                    'effect'       => 'outerShdw',
                    'blur'         => '50800',
                    'distance'     => '38100',
                    'direction'    => '2700000',
                    'algn'         => 'tl',
                    'rotWithShape' => '0'
                ],
                2  => [
                    'effect'       => 'outerShdw',
                    'blur'         => '50800',
                    'distance'     => '38100',
                    'direction'    => '5400000',
                    'algn'         => 't',
                    'rotWithShape' => '0'
                ],
                3  => [
                    'effect'       => 'outerShdw',
                    'blur'         => '50800',
                    'distance'     => '38100',
                    'direction'    => '8100000',
                    'algn'         => 'tr',
                    'rotWithShape' => '0'
                ],
                4  => [
                    'effect'       => 'outerShdw',
                    'blur'         => '50800',
                    'distance'     => '38100',
                    'algn'         => 'l',
                    'rotWithShape' => '0'
                ],
                5  => [
                    'effect'       => 'outerShdw',
                    'size'         => [
                        'sx' => '102000',
                        'sy' => '102000'
                    ],
                    'blur'         => '63500',
                    'distance'     => '38100',
                    'algn'         => 'ctr',
                    'rotWithShape' => '0'
                ],
                6  => [
                    'effect'       => 'outerShdw',
                    'blur'         => '50800',
                    'distance'     => '38100',
                    'direction'    => '10800000',
                    'algn'         => 'r',
                    'rotWithShape' => '0'
                ],
                7  => [
                    'effect'       => 'outerShdw',
                    'blur'         => '50800',
                    'distance'     => '38100',
                    'direction'    => '18900000',
                    'algn'         => 'bl',
                    'rotWithShape' => '0'
                ],
                8  => [
                    'effect'       => 'outerShdw',
                    'blur'         => '50800',
                    'distance'     => '38100',
                    'direction'    => '16200000',
                    'rotWithShape' => '0'
                ],
                9  => [
                    'effect'       => 'outerShdw',
                    'blur'         => '50800',
                    'distance'     => '38100',
                    'direction'    => '13500000',
                    'algn'         => 'br',
                    'rotWithShape' => '0'
                ],
                //INNER
                10 => [
                    'effect'    => 'innerShdw',
                    'blur'      => '63500',
                    'distance'  => '50800',
                    'direction' => '2700000',
                ],
                11 => [
                    'effect'    => 'innerShdw',
                    'blur'      => '63500',
                    'distance'  => '50800',
                    'direction' => '5400000',
                ],
                12 => [
                    'effect'    => 'innerShdw',
                    'blur'      => '63500',
                    'distance'  => '50800',
                    'direction' => '8100000',
                ],
                13 => [
                    'effect'   => 'innerShdw',
                    'blur'     => '63500',
                    'distance' => '50800',
                ],
                14 => [
                    'effect' => 'innerShdw',
                    'blur'   => '114300',
                ],
                15 => [
                    'effect'    => 'innerShdw',
                    'blur'      => '63500',
                    'distance'  => '50800',
                    'direction' => '10800000',
                ],
                16 => [
                    'effect'    => 'innerShdw',
                    'blur'      => '63500',
                    'distance'  => '50800',
                    'direction' => '18900000',
                ],
                17 => [
                    'effect'    => 'innerShdw',
                    'blur'      => '63500',
                    'distance'  => '50800',
                    'direction' => '16200000',
                ],
                18 => [
                    'effect'    => 'innerShdw',
                    'blur'      => '63500',
                    'distance'  => '50800',
                    'direction' => '13500000',
                ],
                //perspective
                19 => [
                    'effect'       => 'outerShdw',
                    'blur'         => '152400',
                    'distance'     => '317500',
                    'size'         => [
                        'sx' => '90000',
                        'sy' => '-19000',
                    ],
                    'direction'    => '5400000',
                    'rotWithShape' => '0',
                ],
                20 => [
                    'effect'       => 'outerShdw',
                    'blur'         => '76200',
                    'direction'    => '18900000',
                    'size'         => [
                        'sy' => '23000',
                        'kx' => '-1200000',
                    ],
                    'algn'         => 'bl',
                    'rotWithShape' => '0',
                ],
                21 => [
                    'effect'       => 'outerShdw',
                    'blur'         => '76200',
                    'direction'    => '13500000',
                    'size'         => [
                        'sy' => '23000',
                        'kx' => '1200000',
                    ],
                    'algn'         => 'br',
                    'rotWithShape' => '0',
                ],
                22 => [
                    'effect'       => 'outerShdw',
                    'blur'         => '76200',
                    'distance'     => '12700',
                    'direction'    => '2700000',
                    'size'         => [
                        'sy' => '-23000',
                        'kx' => '-800400',
                    ],
                    'algn'         => 'bl',
                    'rotWithShape' => '0',
                ],
                23 => [
                    'effect'       => 'outerShdw',
                    'blur'         => '76200',
                    'distance'     => '12700',
                    'direction'    => '8100000',
                    'size'         => [
                        'sy' => '-23000',
                        'kx' => '800400',
                    ],
                    'algn'         => 'br',
                    'rotWithShape' => '0',
                ],
            ];
            return $presets_options[$shadow_presets_option];
        }

        protected function getArrayElementsValue($properties, $elements) {
            $reference = &$properties;
            if (!is_array($elements)) {
                return $reference[$elements];
            } else {
                foreach ($elements as $keys) {
                    $reference = &$reference[$keys];
                }
                return $reference;
            }
            return $this;
        }
    }
